import xlwings as xw
app = xw.App(visible=False, add_book=False)
workbook = app.books.open('F:\\python\\第4章\\员工档案表.xlsx')
worksheet = workbook.sheets[0]
area = worksheet.range('A1:E1')
area.color = (255, 255, 0)
workbook.save('F:\\python\\第4章\\员工档案表1.xlsx')
workbook.close()
app.quit()
